Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TillID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | TillTender(LE_TND_TL) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | TillTender(LE_TND_TL) |
DenominationID (FK)(PK) | An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, etc. | ID_DNM | Identity | integer | Denomination(CO_DNM) |
ISOCurrencyCode (FK)(PK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | Denomination(CO_DNM) |
BalanceTypeCode | Indicates the type of balance this count of currency denomination types refers to. Valid values are: COUNTED This is always based on an actual counted inventory of currency denomination types. | CD_BLNC_TYP | Code | varchar(20) | |
CountedTenderMediaQuantity | The quantity of a specific tender type, denomination bill or coin counted as part of tender settlement. Note that this is not the monetary value but a physical quantity of the money type and denomination. Examples 10 quarters ($2.50) the 10 represents the CountedTenderMediaQuantity. | QU_CNT_MD_UN | QuantityInteger | integer | |